﻿CREATE TABLE [dbo].[ASMS_SettlementBill]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[Number] nvarchar(64) NOT NULL,
	[BusinessId] uniqueidentifier NOT NULL,
	[StationId] uniqueidentifier NOT NULL,
	[MaintenanceBillId] uniqueidentifier NOT NULL,
	[CustomerId] uniqueidentifier NOT NULL,
	[AutomobileId] uniqueidentifier NOT NULL,
	[Amount] money NOT NULL,
	[SpendBalance] money NOT NULL,
	[SpendPoint] money NOT NULL,
	[PaidAmount] money,
	[PaidTime] datetime,
	[CreditAmount] money,
	[PkgReduceAmount] money,
	[Cashier] nvarchar(64),
	[InvoiceType] nvarchar(64),
	[InvoiceNumber] nvarchar(64),
	[Memo] nvarchar(256),
	[CheckOutMemo] nvarchar(256),
	[Status] int NOT NULL,
	[CreatedTime] datetime not null,
	[Creator] nvarchar(64) not null
)
